Snowflake

Snowflake Logo

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Solutions Index


Attribute Value
Publisher Microsoft Corporation
Support Tier Microsoft
Support Link https://support.microsoft.com
Categories Application
Version 3.1.0
Author Microsoft - support@microsoft.com
First Published 2021-10-23
Last Updated 2026-08-10
Solution Folder Snowflake
Marketplace Azure Marketplace · Rating: ★☆☆☆☆ 1.0/5 (2 ratings) · Popularity: 🟢 High (97%)

The Snowflake CCF data connector provides the capability to ingest Snowflake Login History Logs, Query History Logs, User-Grant Logs, Role-Grant Logs, Load History Logs, Materialized View Refresh History Logs, Roles Logs, Tables Logs, Table Storage Metrics Logs, Users Logs into Microsoft Sentinel using the Snowflake SQL API. Refer to Snowflake SQL API documentation for more information.

Underlying Microsoft Technologies used:

This solution takes a dependency on the following technologies, and some of these dependencies either may be in Preview state or might result in additional ingestion or operational costs:

• Microsoft Sentinel Codeless Connector Framework

Contents

Data Connectors

This solution provides 1 data connector(s) (plus 1 discovered⚠️):

🔍 Discovered: This item was discovered by scanning the solution folder but is not listed in the Solution JSON file.

🔶 CLv1: This connector ingests into a table that uses the legacy Custom Log V1 schema format with type-suffixed column names (e.g. _s, _d, _b, _t, _g). Note: identification is based on column name suffixes which are also permitted in CLv2, so this classification may not always be accurate.

Tables Used

This solution uses 21 table(s):

Table Used By Connectors Used By Content
SnowflakeLoadV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeLoad_CL - Analytics, Hunting, Workbooks
SnowflakeLoginV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeLogin_CL - Analytics, Hunting, Workbooks
SnowflakeMaterializedViewV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeMaterializedView_CL - Analytics, Hunting, Workbooks
SnowflakeQueryV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeQuery_CL - Analytics, Hunting, Workbooks
SnowflakeRoleGrantV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeRoleGrant_CL - Analytics, Hunting, Workbooks
SnowflakeRolesV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeRoles_CL - Analytics, Hunting, Workbooks
SnowflakeTableStorageMetricsV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeTableStorageMetrics_CL - Analytics, Hunting, Workbooks
SnowflakeTablesV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeTables_CL - Analytics, Hunting, Workbooks
SnowflakeUserGrantV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeUserGrant_CL - Analytics, Hunting, Workbooks
SnowflakeUsersV2_CL Snowflake (via Codeless Connector Framework) Analytics, Hunting, Workbooks
SnowflakeUsers_CL - Analytics, Hunting, Workbooks
Snowflake_CL 🔶 [DEPRECATED] Snowflake Analytics, Hunting, Workbooks

🔶 CLv1: This table uses the legacy Custom Log V1 schema format with type-suffixed column names (e.g. _s, _d, _b, _t, _g). Note: identification is based on column name suffixes which are also permitted in CLv2, so this classification may not always be accurate.

Content Items

This solution includes 22 content item(s):

Content Type Count
Analytic Rules 10
Hunting Queries 10
Workbooks 1
Parsers 1

Analytic Rules

Name Severity Tactics Tables Used
Snowflake - Abnormal query process time Medium Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Multiple failed queries High Discovery SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Multiple login failures by user High InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Multiple login failures from single IP High InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Possible data destraction Medium Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Possible discovery activity Medium Discovery SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Possible privileges discovery activity Medium Discovery SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Query on sensitive or restricted table Medium Collection SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Unusual query Medium Collection SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - User granted admin privileges Medium PrivilegeEscalation SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL

Hunting Queries

Name Tactics Tables Used
Snowflake - Credit consuming queries Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Deleted databases Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Deleted tables Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Failed logins InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Privileged users' source IP addresses InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Rarely used account InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Rarely used privileged users InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Time consuming queries Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Unknown query type Impact SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL
Snowflake - Users' source IP addresses InitialAccess SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL

Workbooks

Name Tables Used
Snowflake SnowflakeLoadV2_CL
SnowflakeLoad_CL
SnowflakeLoginV2_CL
SnowflakeLogin_CL
SnowflakeMaterializedViewV2_CL
SnowflakeMaterializedView_CL
SnowflakeQueryV2_CL
SnowflakeQuery_CL
SnowflakeRoleGrantV2_CL
SnowflakeRoleGrant_CL
SnowflakeRolesV2_CL
SnowflakeRoles_CL
SnowflakeTableStorageMetricsV2_CL
SnowflakeTableStorageMetrics_CL
SnowflakeTablesV2_CL
SnowflakeTables_CL
SnowflakeUserGrantV2_CL
SnowflakeUserGrant_CL
SnowflakeUsersV2_CL
SnowflakeUsers_CL
Snowflake_CL

Parsers

Name Description Tables Used
Snowflake - SnowflakeLoadV2_CL (read)
SnowflakeLoad_CL (read)
SnowflakeLoginV2_CL (read)
SnowflakeLogin_CL (read)
SnowflakeMaterializedViewV2_CL (read)
SnowflakeMaterializedView_CL (read)
SnowflakeQueryV2_CL (read)
SnowflakeQuery_CL (read)
SnowflakeRoleGrantV2_CL (read)
SnowflakeRoleGrant_CL (read)
SnowflakeRolesV2_CL (read)
SnowflakeRoles_CL (read)
SnowflakeTableStorageMetricsV2_CL (read)
SnowflakeTableStorageMetrics_CL (read)
SnowflakeTablesV2_CL (read)
SnowflakeTables_CL (read)
SnowflakeUserGrantV2_CL (read)
SnowflakeUserGrant_CL (read)
SnowflakeUsersV2_CL (read)
SnowflakeUsers_CL (read)
Snowflake_CL (read)

Release Notes

Version Date Modified (DD-MM-YYYY) Change History
3.1.0 04-08-2026 Updated CCF Data Connector to fix pagination and migrate to V2 tables
3.0.9 03-02-2026 Updated the analytic rule query.
3.0.8 22-12-2025 Added a 120‑minute ingestion delay for the Snowflake connector and updated the parser KQL to surface accurate start/end timestamps.
3.0.7 10-12-2025 Resolved bug in CCF Data Connector related to Output stream for Snowflake tables.
3.0.6 20-11-2025 Resolved bug in CCF Data Connector related to SQL queries
3.0.5 13-10-2025 Updated Parser to support function app table
3.0.4 23-09-2025 Updated parser to extend the normalized fields, and updated Analytic Rules, Workbooks to use CCF connector fields.
3.0.3 09-09-2025 Updated DCR and Poller to prevent redundant data ingestion, improve pagination and handle connection interruptions for Snowflake CCF connector
3.0.2 20-08-2025 Moving Snowflake CCF Data Connector to GA.
3.0.1 26-05-2025 Migrated the Function app connector to CCP Data Connector and Updated Parser
3.0.0 31-08-2023 Manual deployment instructions updated for Data Connector & Convert Parser from text to Yaml

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Solutions Index